{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {},
   "outputs": [],
   "source": [
    "# -*- coding: utf-8 -*-\n",
    "\"\"\"\n",
    "Created on Tue Nov  3 17:28:39 2020\n",
    "\n",
    "@author: 15771\n",
    "\"\"\"\n",
    "import pandas as pd \n",
    "import numpy as np \n",
    "import math\n",
    "\n",
    "def maweisong(*args): #马尾松及其他松类\n",
    "    w = 0.0292*(D**2.8301)+0.0021*(D**3.2818)+0.0021*(D**2.8392)+0.0194*(D**2.3497)\n",
    "    return w\n",
    "def lilei(*args):#栎类\n",
    "    w = 0.1030*(D**2.2950)+0.0160*(D**2.6080)+0.0110*(D**2.2170)+0.1280*(D**2.201)\n",
    "    return w \n",
    "def shamu(*args):#杉木及其他杉类\n",
    "    w = 0.0543*(D**2.4242)+0.0255*(D**2.0726)+0.0773*(D**1.5761)+0.0513*(D**2.0338)\n",
    "    return w \n",
    "def baimu(*args):#柏木\n",
    "    w = 0.0937*(D**2.2225)+0.0323*(D**2.3338)+0.0236*(D**2.3106)+0.057*(D**2.1651)\n",
    "    return w\n",
    "def yunshan(*args):#云杉、冷杉\n",
    "    w = 0.0562*(D**2.4608)+0.1298*(D**1.8070)+0.1436*(D**1.6729)+0.0313*(D**2.3049)\n",
    "    return w\n",
    "def huamu(*args):#桦木\n",
    "    w = 0.1555*(D**2.2273)+0.0134*(D**2.4932)+0.0092*(D**2.0967)+0.0242*(D**2.4750)\n",
    "    return w\n",
    "def luoyesong(*args):#落叶松\n",
    "    w = 0.0526*(D**2.5257)+0.0085*(D**2.4815)+0.0168*(D**2.0026)+0.0291*(D**2.2645)\n",
    "    return w\n",
    "def hongsong(*args):#红松\n",
    "    w = 0.1087*(D**2.1527)+0.0481*(D**2.0877)+0.0631*(D**1.8343)+0.0305*(D**2.3298)\n",
    "    return w\n",
    "def yunnansong(*args):#云南松\n",
    "    w = 0.0900*(D**3.4678)+0.0310*(D**3.3250)+0.0298*(D**2.3596)+0.4432*(D**2.6927)\n",
    "    return w\n",
    "def huashansong(*args):#华山松\n",
    "    w = 0.0787*(D**2.2823)+0.0270*(D**2.3664)+0.0046*(D**2.5540)+0.0224*(D**2.2836)\n",
    "    return w\n",
    "def yousong(*args):#油松\n",
    "    w = 0.1450*(D**2.1567)+0.0673*(D**1.9781)+0.0600*(D**1.9329)+0.0503*(D**2.0886)\n",
    "    return w\n",
    "def zhangzisong(*args):#樟子松\n",
    "    w = 0.0840*(D**2.2337)+0.0691*(D**1.7370)+0.0994*(D**1.8157)+0.2645*(D**1.4197)\n",
    "    return w\n",
    "def qitayingkuo(*args):#其他硬阔类\n",
    "    w = 0.0971*(D**2.3253)+0.0278*(D**2.3540)+0.0239*(D**2.0051)+0.0529*(D**2.2317)\n",
    "    return w\n",
    "def anshu(*args):#桉树\n",
    "    w = 0.0349*(D**2.7913)+0.0701*(D**1.7318)+0.0175*(D**2.4165)+0.0186*(D**2.3163)\n",
    "    return w\n",
    "def yangshu(*args):#杨树\n",
    "    w = 0.0800*(D**2.3350)+0.0210*(D**2.3400)+0.0120*(D**2.0130)+0.0360*(D**2.1920)\n",
    "    return w\n",
    "def qitaruankuo(*args):#其他软阔类\n",
    "    w = 0.1286*(D**2.2255)+0.0445*(D**1.9516)+0.0197*(D**1.6667)+0.0630*(D**2.0316)\n",
    "    return w\n",
    "def tieshan(*args):#铁杉、柳杉、油杉\n",
    "    w = 0.1909*(D**1.9859)+0.0205*(D**2.2230)+0.0453*(D**1.8432)+0.0223*(D**2.3840)\n",
    "    return w\n",
    "def zhenyelin(*args):#针叶林\n",
    "    w = 0.0670*(D**2.4090)+0.0220*(D**2.2700)+0.0250*(D**2.1240)+0.0380*(D**2.1650)\n",
    "    return w\n",
    "def kuoyelin(*args):#阔叶混\n",
    "    w = 0.1300*(D**2.2010)+0.0380*(D**2.1650)+0.0130*(D**2.0630)+0.0570*(D**2.1710)\n",
    "    return w\n",
    "def zhenkuohunjiaolin(*args):#针阔混\n",
    "    w = 0.0610*(D**2.4590)+0.0970*(D**1.8460)+0.1330*(D**1.4550)+0.0960*(D**1.9280)\n",
    "    return w\n",
    "def shuanpili(*args):#栓皮栎\n",
    "    w = 0.0554*(D**1.7229)+0.0141*(D**1.5988)+0.0120*(D**1.6030)+0.0261*(D**1.6906)\n",
    "    return w\n",
    "def xiangzhang(*args):#香樟\n",
    "    w = 0.0250*(D**2.7300)+0.0020*(D**3.0880)+0.0070*(D**2.4470)+0.0070*(D**2.8190)\n",
    "    return w\n",
    "def muhe(*args):#木荷\n",
    "    w = 0.0803*(D**2.4096)+0.1857*(D**1.6599)+0.0246*(D**1.8790)+0.0343*(D**2.2451)\n",
    "    return w\n",
    "def fengxiang(*args):#枫香\n",
    "    w = 0.1997*(D**2.0511)+0.1537*(D**1.6627)+1.3336*(D**0.5549)+0.2450*(D**1.6905)\n",
    "    return w\n",
    "def shuishan(*args):#水杉\n",
    "    w = 0.0287*(D**2.6604)+0.0402*(D**1.9898)+0.1317*(D**1.2972)+0.0172*(D**2.3939)\n",
    "    return w\n",
    "def qinggangli(*args):#青冈栎\n",
    "    w = 0.1366*(D**2.2845)+0.0069*(D**2.9094)+0.0011*(D**3.0210)+0.0434*(D**2.4476)\n",
    "    return w\n",
    "if __name__ =='__main__':\n",
    "    file = open(r'./使用数据/一清样地数据.csv')\n",
    "    data = pd.read_csv(file)\n",
    "    df = pd.DataFrame(data)\n",
    "    name_list = list(df['树种名称'])\n",
    "    new_list = []\n",
    "    for i in range(len(name_list)):\n",
    "        if name_list[i] == '马尾松': #马尾松及其他松类\n",
    "            D = df.loc[i]['胸径']\n",
    "            maweisong_val = maweisong(D)\n",
    "            new_list.append(maweisong_val)\n",
    "        elif name_list[i] == '栓皮栎':#栓皮栎\n",
    "            D = df.loc[i]['胸径']\n",
    "            shuanpili_val = shuanpili(D)\n",
    "            new_list.append(shuanpili_val)\n",
    "        elif name_list[i] == '栎':\n",
    "            D = df.loc[i]['胸径']\n",
    "            lilei_val = lilei(D)\n",
    "            new_list.append(lilei_val)\n",
    "        elif name_list[i] == '其他软阔类':#其他软阔类\n",
    "            D = df.loc[i]['胸径']\n",
    "            qitaruankuo_val = qitaruankuo(D)\n",
    "            new_list.append(qitaruankuo_val)    \n",
    "        elif name_list[i] == '柏木':#柏木\n",
    "            D = df.loc[i]['胸径']\n",
    "            baimu_val = baimu(D)\n",
    "            new_list.append(baimu_val)\n",
    "        elif name_list[i] == '榆':#其他硬阔类\n",
    "            D = df.loc[i]['胸径']\n",
    "            qitayingkuo_val = qitayingkuo(D)\n",
    "            new_list.append(qitayingkuo_val)\n",
    "        elif name_list[i] == '樟':#香樟\n",
    "            D = df.loc[i]['胸径']\n",
    "            xiangzhang_val = xiangzhang(D)\n",
    "            new_list.append(xiangzhang_val)\n",
    "        elif name_list[i] == '其他硬阔':#其他硬阔类\n",
    "            D = df.loc[i]['胸径']\n",
    "            qitayingkuo_val = qitayingkuo(D)\n",
    "            new_list.append(qitayingkuo_val)\n",
    "        elif name_list[i] == '杨树':\n",
    "            D = df.loc[i]['胸径']\n",
    "            yangshu_val = yangshu(D)\n",
    "            new_list.append(yangshu_val)\n",
    "        elif name_list[i] == '杉木':#杉木及其他杉类\n",
    "            D = df.loc[i]['胸径']\n",
    "            shamu_val = shamu(D)\n",
    "            new_list.append(shamu_val)    \n",
    "        elif name_list[i] == '柳树':#其他软阔类\n",
    "            D = df.loc[i]['胸径']\n",
    "            qitaruankuo_val = qitaruankuo(D)\n",
    "            new_list.append(qitaruankuo_val)    \n",
    "        elif name_list[i] == '黑松': #马尾松及其他松类\n",
    "            D = df.loc[i]['胸径']\n",
    "            maweisong_val = maweisong(D)\n",
    "            new_list.append(maweisong_val)    \n",
    "        elif name_list[i] == '泡桐':#其他软阔类\n",
    "            D = df.loc[i]['胸径']\n",
    "            qitaruankuo_val = qitaruankuo(D)\n",
    "            new_list.append(qitaruankuo_val)\n",
    "        elif name_list[i] == '楝树':#其他软阔类\n",
    "            D = df.loc[i]['胸径']\n",
    "            qitaruankuo_val = qitaruankuo(D)\n",
    "            new_list.append(qitaruankuo_val)\n",
    "        elif name_list[i] == '兴山榆（天然）':#其他硬阔类\n",
    "            D = df.loc[i]['胸径']\n",
    "            qitayingkuo_val = qitayingkuo(D)\n",
    "            new_list.append(qitayingkuo_val)\n",
    "        elif name_list[i] == '桦木':\n",
    "            D = df.loc[i]['胸径']\n",
    "            huamu_val = huamu(D)\n",
    "            new_list.append(huamu_val)\n",
    "        elif name_list[i] == '白桦':#其他硬阔类\n",
    "            D = df.loc[i]['胸径']\n",
    "            qitayingkuo_val = qitayingkuo(D)\n",
    "            new_list.append(qitayingkuo_val)    \n",
    "        elif name_list[i] == '椴树':#其他软阔类\n",
    "            D = df.loc[i]['胸径']\n",
    "            qitaruankuo_val = qitaruankuo(D)\n",
    "            new_list.append(qitaruankuo_val)\n",
    "        elif name_list[i] == '铁杉':\n",
    "            D = df.loc[i]['胸径']\n",
    "            tieshan_val = tieshan(D)\n",
    "            new_list.append(tieshan_val)\n",
    "        elif name_list[i] == '柳杉':\n",
    "            D = df.loc[i]['胸径']\n",
    "            tieshan_val = tieshan(D)\n",
    "            new_list.append(tieshan_val)\n",
    "        elif name_list[i] == '枫香':\n",
    "            D = df.loc[i]['胸径']\n",
    "            fengxiang_val = fengxiang(D)\n",
    "            new_list.append(fengxiang_val)\n",
    "        elif name_list[i] == '湿地松': #马尾松及其他松类\n",
    "            D = df.loc[i]['胸径']\n",
    "            maweisong_val = maweisong(D)\n",
    "            new_list.append(maweisong_val)   \n",
    "        elif name_list[i] == '油松': #马尾松及其他松类\n",
    "            D = df.loc[i]['胸径']\n",
    "            yousong_val = yousong(D)\n",
    "            new_list.append(yousong_val)  \n",
    "        elif name_list[i] == '其他杉类':#杉木及其他杉类\n",
    "            D = df.loc[i]['胸径']\n",
    "            shamu_val = shamu(D)\n",
    "            new_list.append(shamu_val)\n",
    "        elif name_list[i] == '油杉':\n",
    "            D = df.loc[i]['胸径']\n",
    "            tieshan_val = tieshan(D)\n",
    "            new_list.append(tieshan_val)\n",
    "        elif name_list[i] == '华山松':\n",
    "            D = df.loc[i]['胸径']\n",
    "            huashansong_val = huashansong(D)\n",
    "            new_list.append(huashansong_val)\n",
    "        elif name_list[i] == '日本落叶松': #马尾松及其他松类\n",
    "            D = df.loc[i]['胸径']\n",
    "            maweisong_val = maweisong(D)\n",
    "            new_list.append(maweisong_val)   \n",
    "        elif name_list[i] == '楠':#其他硬阔类\n",
    "            D = df.loc[i]['胸径']\n",
    "            qitayingkuo_val = qitayingkuo(D)\n",
    "            new_list.append(qitayingkuo_val)    \n",
    "        elif name_list[i] == '冷杉':\n",
    "            D = df.loc[i]['胸径']\n",
    "            yunshan_val = yunshan(D)\n",
    "            new_list.append(yunshan_val)\n",
    "        elif name_list[i] == '其他松类': #马尾松及其他松类\n",
    "            D = df.loc[i]['胸径']\n",
    "            maweisong_val = maweisong(D)\n",
    "            new_list.append(maweisong_val)   \n",
    "        elif name_list[i] == '池杉':#杉木及其他杉类\n",
    "            D = df.loc[i]['胸径']\n",
    "            shamu_val = shamu(D)\n",
    "            new_list.append(shamu_val)   \n",
    "        elif name_list[i] == '水杉':\n",
    "            D = df.loc[i]['胸径']\n",
    "            shuishan_val = shuishan(D)\n",
    "            new_list.append(shuishan_val)    \n",
    "        elif name_list[i] == '黄山松': #马尾松及其他松类\n",
    "            D = df.loc[i]['胸径']\n",
    "            maweisong_val = maweisong(D)\n",
    "            new_list.append(maweisong_val)       \n",
    "        elif name_list[i] == '檫木':#其他软阔类\n",
    "            D = df.loc[i]['胸径']\n",
    "            qitaruankuo_val = qitaruankuo(D)\n",
    "            new_list.append(qitaruankuo_val)   \n",
    "        elif name_list[i] == '乌桕':#阔叶林\n",
    "            D = df.loc[i]['胸径']\n",
    "            kuoyelin_val = kuoyelin(D)\n",
    "            new_list.append(kuoyelin_val)\n",
    "        elif name_list[i] == '柿':#阔叶林\n",
    "            D = df.loc[i]['胸径']\n",
    "            kuoyelin_val = kuoyelin(D)\n",
    "            new_list.append(kuoyelin_val)\n",
    "        elif name_list[i] == '油桐':#阔叶林\n",
    "            D = df.loc[i]['胸径']\n",
    "            kuoyelin_val = kuoyelin(D)\n",
    "            new_list.append(kuoyelin_val)\n",
    "        elif name_list[i] == '其他（药材）':#阔叶林\n",
    "            D = df.loc[i]['胸径']\n",
    "            kuoyelin_val = kuoyelin(D)\n",
    "            new_list.append(kuoyelin_val)\n",
    "        elif name_list[i] == '杏':#阔叶林\n",
    "            D = df.loc[i]['胸径']\n",
    "            kuoyelin_val = kuoyelin(D)\n",
    "            new_list.append(kuoyelin_val)\n",
    "        elif name_list[i] == '蚕桑':#阔叶林\n",
    "            D = df.loc[i]['胸径']\n",
    "            kuoyelin_val = kuoyelin(D)\n",
    "            new_list.append(kuoyelin_val)\n",
    "        elif name_list[i] == '核桃':#阔叶林\n",
    "            D = df.loc[i]['胸径']\n",
    "            kuoyelin_val = kuoyelin(D)\n",
    "            new_list.append(kuoyelin_val)\n",
    "        elif name_list[i] == '枣':#阔叶林\n",
    "            D = df.loc[i]['胸径']\n",
    "            kuoyelin_val = kuoyelin(D)\n",
    "            new_list.append(kuoyelin_val)\n",
    "        elif name_list[i] == '桃':#阔叶林\n",
    "            D = df.loc[i]['胸径']\n",
    "            kuoyelin_val = kuoyelin(D)\n",
    "            new_list.append(kuoyelin_val)\n",
    "        elif name_list[i] == '白蜡树':#阔叶林\n",
    "            D = df.loc[i]['胸径']\n",
    "            kuoyelin_val = kuoyelin(D)\n",
    "            new_list.append(kuoyelin_val)\n",
    "        elif name_list[i] == '其他（果树）':#阔叶林\n",
    "            D = df.loc[i]['胸径']\n",
    "            kuoyelin_val = kuoyelin(D)\n",
    "            new_list.append(kuoyelin_val)\n",
    "        elif name_list[i] == '山楂':#阔叶林\n",
    "            D = df.loc[i]['胸径']\n",
    "            kuoyelin_val = kuoyelin(D)\n",
    "            new_list.append(kuoyelin_val)\n",
    "        elif name_list[i] == '其他（药材）漆树':#阔叶林\n",
    "            D = df.loc[i]['胸径']\n",
    "            kuoyelin_val = kuoyelin(D)\n",
    "            new_list.append(kuoyelin_val)\n",
    "        elif name_list[i] == '板栗':#阔叶林\n",
    "            D = df.loc[i]['胸径']\n",
    "            kuoyelin_val = kuoyelin(D)\n",
    "            new_list.append(kuoyelin_val)\n",
    "        elif name_list[i] == '梨':#阔叶林\n",
    "            D = df.loc[i]['胸径']\n",
    "            kuoyelin_val = kuoyelin(D)\n",
    "            new_list.append(kuoyelin_val)\n",
    "        elif name_list[i] == '李':#阔叶林\n",
    "            D = df.loc[i]['胸径']\n",
    "            kuoyelin_val = kuoyelin(D)\n",
    "            new_list.append(kuoyelin_val)\n",
    "        elif name_list[i] == '油茶':#阔叶林\n",
    "            D = df.loc[i]['胸径']\n",
    "            kuoyelin_val = kuoyelin(D)\n",
    "            new_list.append(kuoyelin_val)\n",
    "        elif name_list[i] == '杜仲':#阔叶林\n",
    "            D = df.loc[i]['胸径']\n",
    "            kuoyelin_val = kuoyelin(D)\n",
    "            new_list.append(kuoyelin_val)\n",
    "        elif name_list[i] == '其他（林化业原料）':#阔叶林\n",
    "            D = df.loc[i]['胸径']\n",
    "            kuoyelin_val = kuoyelin(D)\n",
    "            new_list.append(kuoyelin_val)\n",
    "        elif name_list[i] == '肉桂':#阔叶林\n",
    "            D = df.loc[i]['胸径']\n",
    "            kuoyelin_val = kuoyelin(D)\n",
    "            new_list.append(kuoyelin_val)\n",
    "        elif name_list[i] == '银杏':#阔叶林\n",
    "            D = df.loc[i]['胸径']\n",
    "            kuoyelin_val = kuoyelin(D)\n",
    "            new_list.append(kuoyelin_val)\n",
    "        elif name_list[i] == '黄柏':#阔叶林\n",
    "            D = df.loc[i]['胸径']\n",
    "            kuoyelin_val = kuoyelin(D)\n",
    "            new_list.append(kuoyelin_val)\n",
    "        elif name_list[i] == '八角':#阔叶林\n",
    "            D = df.loc[i]['胸径']\n",
    "            kuoyelin_val = kuoyelin(D)\n",
    "            new_list.append(kuoyelin_val)\n",
    "        elif name_list[i] == '杜鹃':#阔叶林\n",
    "            D = df.loc[i]['胸径']\n",
    "            kuoyelin_val = kuoyelin(D)\n",
    "            new_list.append(kuoyelin_val)\n",
    "        elif name_list[i] == '蚕柞':#阔叶林\n",
    "            D = df.loc[i]['胸径']\n",
    "            kuoyelin_val = kuoyelin(D)\n",
    "            new_list.append(kuoyelin_val)\n",
    "        elif name_list[i] == '苹果':#阔叶林\n",
    "            D = df.loc[i]['胸径']\n",
    "            kuoyelin_val = kuoyelin(D)\n",
    "            new_list.append(kuoyelin_val)\n",
    "        elif name_list[i] == '厚朴':#阔叶林\n",
    "            D = df.loc[i]['胸径']\n",
    "            kuoyelin_val = kuoyelin(D)\n",
    "            new_list.append(kuoyelin_val)\n",
    "        elif name_list[i] == '其他（食用原料）':#阔叶林\n",
    "            D = df.loc[i]['胸径']\n",
    "            kuoyelin_val = kuoyelin(D)\n",
    "            new_list.append(kuoyelin_val)\n",
    "        elif name_list[i] == '枫桦':#其他硬阔类\n",
    "            D = df.loc[i]['胸径']\n",
    "            qitayingkuo_val = qitayingkuo(D)\n",
    "            new_list.append(qitayingkuo_val)  \n",
    "        elif name_list[i] == '木荷':#其他硬阔类\n",
    "            D = df.loc[i]['胸径']\n",
    "            muhe_val = muhe(D)\n",
    "            new_list.append(muhe_val)       \n",
    "        elif name_list[i] == '火炬松': #马尾松及其他松类\n",
    "            D = df.loc[i]['胸径']\n",
    "            maweisong_val = maweisong(D)\n",
    "            new_list.append(maweisong_val)\n",
    "        elif name_list[i] == '红豆杉（天然）': #马尾松及其他松类\n",
    "            D = df.loc[i]['胸径']\n",
    "            zhenyelin_val = zhenyelin(D)\n",
    "            new_list.append(zhenyelin_val)\n",
    "        elif name_list[i] == '国外松': #马尾松及其他松类\n",
    "            D = df.loc[i]['胸径']\n",
    "            maweisong_val = maweisong(D)\n",
    "            new_list.append(maweisong_val)  \n",
    "    df['bio'] = new_list\n",
    "    #print(df)\n",
    "    df.to_csv(r'./输出数据\\样木生物量.csv',index = False, encoding=\"gbk\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>样地号</th>\n",
       "      <th>样木号</th>\n",
       "      <th>立木类型</th>\n",
       "      <th>树种代码</th>\n",
       "      <th>树种名称</th>\n",
       "      <th>胸径原</th>\n",
       "      <th>样地类别</th>\n",
       "      <th>地类</th>\n",
       "      <th>树种大类代码</th>\n",
       "      <th>胸径</th>\n",
       "      <th>bio</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>5</td>\n",
       "      <td>7</td>\n",
       "      <td>11</td>\n",
       "      <td>828</td>\n",
       "      <td>栓皮栎</td>\n",
       "      <td>120</td>\n",
       "      <td>11</td>\n",
       "      <td>111</td>\n",
       "      <td>10</td>\n",
       "      <td>12.0</td>\n",
       "      <td>7.142893</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>5</td>\n",
       "      <td>8</td>\n",
       "      <td>11</td>\n",
       "      <td>828</td>\n",
       "      <td>栓皮栎</td>\n",
       "      <td>129</td>\n",
       "      <td>11</td>\n",
       "      <td>111</td>\n",
       "      <td>10</td>\n",
       "      <td>12.9</td>\n",
       "      <td>8.072243</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>5</td>\n",
       "      <td>14</td>\n",
       "      <td>11</td>\n",
       "      <td>828</td>\n",
       "      <td>栓皮栎</td>\n",
       "      <td>140</td>\n",
       "      <td>11</td>\n",
       "      <td>111</td>\n",
       "      <td>10</td>\n",
       "      <td>14.0</td>\n",
       "      <td>9.270538</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>5</td>\n",
       "      <td>51</td>\n",
       "      <td>11</td>\n",
       "      <td>828</td>\n",
       "      <td>栓皮栎</td>\n",
       "      <td>125</td>\n",
       "      <td>11</td>\n",
       "      <td>111</td>\n",
       "      <td>10</td>\n",
       "      <td>12.5</td>\n",
       "      <td>7.653456</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>5</td>\n",
       "      <td>52</td>\n",
       "      <td>11</td>\n",
       "      <td>828</td>\n",
       "      <td>栓皮栎</td>\n",
       "      <td>101</td>\n",
       "      <td>11</td>\n",
       "      <td>111</td>\n",
       "      <td>10</td>\n",
       "      <td>10.1</td>\n",
       "      <td>5.336862</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>101088</th>\n",
       "      <td>8710</td>\n",
       "      <td>110</td>\n",
       "      <td>11</td>\n",
       "      <td>799</td>\n",
       "      <td>其他（食用原料）</td>\n",
       "      <td>52</td>\n",
       "      <td>11</td>\n",
       "      <td>111</td>\n",
       "      <td>21</td>\n",
       "      <td>5.2</td>\n",
       "      <td>8.678262</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>101089</th>\n",
       "      <td>8904</td>\n",
       "      <td>114</td>\n",
       "      <td>11</td>\n",
       "      <td>799</td>\n",
       "      <td>其他（食用原料）</td>\n",
       "      <td>67</td>\n",
       "      <td>11</td>\n",
       "      <td>111</td>\n",
       "      <td>21</td>\n",
       "      <td>6.7</td>\n",
       "      <td>15.088176</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>101090</th>\n",
       "      <td>8907</td>\n",
       "      <td>112</td>\n",
       "      <td>11</td>\n",
       "      <td>799</td>\n",
       "      <td>其他（食用原料）</td>\n",
       "      <td>72</td>\n",
       "      <td>11</td>\n",
       "      <td>111</td>\n",
       "      <td>21</td>\n",
       "      <td>7.2</td>\n",
       "      <td>17.654425</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>101091</th>\n",
       "      <td>8907</td>\n",
       "      <td>122</td>\n",
       "      <td>11</td>\n",
       "      <td>799</td>\n",
       "      <td>其他（食用原料）</td>\n",
       "      <td>66</td>\n",
       "      <td>11</td>\n",
       "      <td>111</td>\n",
       "      <td>21</td>\n",
       "      <td>6.6</td>\n",
       "      <td>14.601048</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>101092</th>\n",
       "      <td>9087</td>\n",
       "      <td>115</td>\n",
       "      <td>11</td>\n",
       "      <td>799</td>\n",
       "      <td>其他（食用原料）</td>\n",
       "      <td>62</td>\n",
       "      <td>11</td>\n",
       "      <td>111</td>\n",
       "      <td>21</td>\n",
       "      <td>6.2</td>\n",
       "      <td>12.738812</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>101093 rows × 11 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "         样地号  样木号  立木类型  树种代码      树种名称  胸径原  样地类别   地类  树种大类代码    胸径  \\\n",
       "0          5    7    11   828       栓皮栎  120    11  111      10  12.0   \n",
       "1          5    8    11   828       栓皮栎  129    11  111      10  12.9   \n",
       "2          5   14    11   828       栓皮栎  140    11  111      10  14.0   \n",
       "3          5   51    11   828       栓皮栎  125    11  111      10  12.5   \n",
       "4          5   52    11   828       栓皮栎  101    11  111      10  10.1   \n",
       "...      ...  ...   ...   ...       ...  ...   ...  ...     ...   ...   \n",
       "101088  8710  110    11   799  其他（食用原料）   52    11  111      21   5.2   \n",
       "101089  8904  114    11   799  其他（食用原料）   67    11  111      21   6.7   \n",
       "101090  8907  112    11   799  其他（食用原料）   72    11  111      21   7.2   \n",
       "101091  8907  122    11   799  其他（食用原料）   66    11  111      21   6.6   \n",
       "101092  9087  115    11   799  其他（食用原料）   62    11  111      21   6.2   \n",
       "\n",
       "              bio  \n",
       "0        7.142893  \n",
       "1        8.072243  \n",
       "2        9.270538  \n",
       "3        7.653456  \n",
       "4        5.336862  \n",
       "...           ...  \n",
       "101088   8.678262  \n",
       "101089  15.088176  \n",
       "101090  17.654425  \n",
       "101091  14.601048  \n",
       "101092  12.738812  \n",
       "\n",
       "[101093 rows x 11 columns]"
      ]
     },
     "execution_count": 2,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.6.4"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}
